package com.site.dao;

import com.site.pojo.ElectricWireSize;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * FileName: ElectricWireSizeDao.java
 * 电线规格表Dao
 *
 * @author 田尚忠
 * @Date    2021/11/28
 * @version 1.00
 */
public interface ElectricWireSizeDao {
    /*查询方法*/

        //查询全部
        List<ElectricWireSize> selectAll() throws SQLException;

        //按照id查询
        ElectricWireSize selectByid(int id) throws SQLException;

        //通过商品id查询
        List<ElectricWireSize> selectByGoodsid(int id) throws SQLException;


    /*增加方法*/

        //新增电线规格
        int addElectricWireSize(ElectricWireSize electricWireSize);
        int addElectricWireSize(Connection conn,ElectricWireSize electricWireSize);


    /*删除方法*/

        //通过id删除CircuitBoardSize
        int delElectricWireSizeByid(int id);
        int delElectricWireSizeByid(Connection conn, int id);

        //通过商品id删除CircuitBoardSize
        int delElectricWireSizeByGoodsid(int id);
        int delElectricWireSizeByGoodsid(Connection conn,int id);


    /*修改方法*/

        //通过id修改CircuitBoardSize
        int updateElectricWireSize(int id,ElectricWireSize electricWireSize);
        int updateElectricWireSize(Connection conn,int id,ElectricWireSize electricWireSize);
}
